home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
AOL File Library: 2,801 to 2,900
/
aol-file-protocol-4400-2801-to-2900.zip
/
AOLDLs
/
TAWUG
/
TAWUG Disk No. 21 (SHK)
/
TAWUG.21.shk
/
NETRO.NOTES.86C
(
.txt
)
< prev
next >
Wrap
AppleWorks Document
|
1986-02-02
|
11KB
|
182 lines
O=====|====|====|====|====|====|====|====|====|====|====|====|====|====|====|===
ROBERT J. NETRO
1606 GREENWAY RD SE
NORTH CANTON, OHIO
(216) 497-7540
January 28, 1986
Dear Jim:
LSomehow I get the distinct impression members aren't contacting you as much O
Mas they once did. If they were, I would have expected to have heard from at K
Ileast one on information to expand the membership database in my revised M
Kformat. What is the current status of TAWUG? Have you made a decision on N
Lhow to continue operations? Please call me collect when you get a chance. M
KFor better or worse, I've tried to contribute files and hoped others would N
Lcontinue to do likewise. Also in recent notes I tried to get more dialogue I
Ginto the act. The contributions in these notes (86C) should stimulate &
someone to get into such a dialogue.
===================================================================
From: Robert J. Netro
1606 Greenway Rd SE
North Canton, OH 44709
(216) 497-7540
SUBJ:
More Notes on Spreadsheet Templates
DIn past NOTES an Amortization Model was modified to demonstate some N
Ltechniques learned the "hard way" and to encourage others to participate in N
Lthis process. By initiating such an exchange others might find it a useful G
Emethod of contributing by starting development of other Templates in :
different areas. These could be SS, DB, Integated, etc.
GIn this NOTE the previous template Amort.Netro.III will be modified as K
IAmort.Netro.IV to show an amortization with "Constant Principal" vs. the J
Hpresent "Constant Payment" approach. In the classical constant payment O
Mmethod, interest decreases as a part of each payment and the contribution to I
Gprincipal payoff increases. In this alternative model the "Principal" H
Fcontribution remains constant while both the interest portion and the P
Nperiodic payments decrease. The generality of variable Payments/Year is left
intact.
KA partial example follows. Note here the "First Payment" is calculated in K
Ithe "Loan Summary." As previously mentioned, both interest and payments M
Kdecrease. Also a column called "Payment" has been added. There is a more K
Icomplex formula for calculations involving "Constant Principal" Payments N
Lhowever it wasn't required here and will be saved for another time where it O
Mwill serve a more universal purpose. That is in the present model I require J
Hyou to specify the amount of the principal payment and with that and an M
Kinterest computation, payment is determined. Later on it will be handy to M
Kspecify a first payment and be able to compute the amount of the "Constant
Principal."
Recommend some attempts to test the model for familiarization.
============================================================================9
AMORTIZATION TABLE (Amort.Netro.IV)N
=============================================================================
Loan Summary =====================
------------ "Constant Principal"=
Loan Amount 1000.00 ====================
Interest Rate .100
Loan Term (Years) 4
Payments/Year 12
Total No. Payments 48
Constant Principal 5.00A
First Payment 13.33 ========================<
Total Interest Pd 273.75 <------ As these values are@
Total Principal Pd 180.00 <------ computed last, use OA-KA
Principal Left 453.75 <------ twice to update results.A
========================N
============================================================================
Loan Activity
-------------N
INTEREST PRINCIPAL PAYMENT RESID.BALN
-------- --------- -------- ---------N
Loan Begins 0.00 0.00 0.00 1000.00N
Mar 84 1 8.33 5.00 13.33 995.00N
Apr 2 8.29 5.00 13.29 990.00
===================================================================
From: Robert J. Netro
1606 Greenway Rd SE
North Canton, OH 44709
(216) 497-7540
SUBJ:
Note On How To Make the Computer Work Hard.
MWhen we use programs like AppleWorks and run fairly simple applications such P
Nas a current series of Ammortization Templates, everything appears to process L
Jquite rapidly. In our human span of time orientation and capabilities to K
Ihandle quantities of data in algebraic formuli the rapidity is amazing. G
ETherefore I would like to share an example which shows "how slow and I
Gincapable" the computer is! Actually this is a facitious but possibly
interesting experiment.
NWhat I've done is to develop a SS Template for computing logorithmns. It may M
Kbe on this disk (either side) entitled "LN.FUNCTION." Roger Vancil did an L
Joutstanding job in his recent submissions on TAWUG disks. In fact if you N
Lwant to use AppleWorks for logorithmn applications
PLEASE
use his files. N
LIn this Note I want to show a "tediously developed" template to make up for N
Ldeficiencies in AppleWorks and how it not only doesn't accomplish very much =
but it takes "forever" to run. At least it seems that way!
NWithout going into all the development, this template will allow you to enter L
Jany real number (x) for which logorithmns might be calculated and with an M
K"OA-K
twice" iterative process find a solution for BOTH ln(x) and log(x). O
MWhat happens is at least twofold. First you will get a set of answers which N
Lfor "x
equal to or less than 50" is OK! Beyond that the accuracy falls off K
Ito the point the model is ridiculous. It would take numerous additional O
Mequations to add to the accuracy for larger values of "x." The effort even P
Nmore interesting to me is the time it takes to complete the calculations. Try J
Hit and see. The set of calculations in the Taylor's Series are summed. O
MExamine some of them. If nothing else this should give all of us a feel for C
Awhat it takes to "build" a function into a program. Part of the 8
"LN.FUNCTION" output is reproduced here as an example.
=====================
LOGARITHMIC FUNCTIONS
=====================.
METHOD EMPLOYED USES PARTIAL TAYLOR SERIES
For x > 0
Enter x--> 40.00 (x-1)/(x+1)= .9512195A
(USE "OA-K" TWICE) Taylor Series Formuli<
ln x =3.6888794 1.3938652<
.1715033<
e =2.7182818 .0925959<
.0566238<
CHECK --> x = 40.00 .0370108<
.0252207<
log x =1.6020601 .0176850<
.0126622<
CHECK --> x = 40.00 .0092112<
.0067851<
The check figures show how accurate .0050488<
ln/log results are. .0037883
** In the LN.FUNCTION template you will see the Taylor Series is much longer!
FThe fun here is to enter various values for "x." (Everything else is P
Nprotected.) Count how long it takes to calculate. My unofficial estimate is <
several minutes while you stare at "Column F calculating."
===================================================================
From: Robert J. Netro
1606 Greenway Rd SE
North Canton, OH 44709
(216) 497-7540
SUBJ:
Whither Database or Spreadsheet?
KIs the AppleWorks Database or Spreadsheet better for certain applications? I
GCan both be used in the same application to maximize benefits of each? P
NGenerally one uses a spreadsheet when calculations dominate recordkeeping and O
Mvice versa. Viewing a full database file is cumbersome without printing, and J
Hcalculations are limited. Spreadsheets lack the flexibility of multiple M
report designs. One
Solution
is combine them! An actual example follows.
NCompany "M" sells a variety of products from several dozen firms. Prices vary N
Lby volume, customer, service, etc., and costs change periodically. Salesmen N
Lneed "on hand" data to minimize stockouts when taking orders. M's customers P
Nwon't tolerate the unknown and M's computer doesn't have perpetual inventory. )
The Sales Manager's AIIc is available.
GFirst a database file collected all product line info except costs and M
Kvariable prices. Each record has 25 fields with 5 "spares" to avoid report K
Iredesign when new fields are needed. Inventory data on this file is kept L
Jcurrent with product receipts and sales entered daily, a 30 minute chore. P
NInventory is entered when available. Daily printouts are given to salesmen. B
Paper is cheap compared to lost business from unhappy customers.
HThis database file was converted to a spreadsheet using the DIF method. L
JCost/price data was added and inventory related columns were moved to the L
Jright of other information as it may be useful to use the spreadsheet for L
Jinventory and other analyses in MOD.II. The different price schedules are L
Jformula derived, a natural for the spreadsheet but beyond the three field I
Gcapacity of the database. Printouts (less inventory data) are made for N
Lsalesmen and revised periodically. In M's case monthly is adequate. Interim I
Gadditions, deletions, and minor changes can be made to the spreadsheet
printouts from memoranda.
MEntering and organizing records in the database saves hours by being able to O
Mgo through the "DIF" and creating a complimentary spreadsheet template which F
Dwith a few column inserts and formula additions can allow important K
Icalculations. Additional benefits accrue from: key data accessible from P
Neither or both files in a variety of report formats for management, salesmen, M
Kwarehouse, and customers; retention of data analysis with the spreadsheet; N
Land ability to use a mailmerge capability integrating the database and word 1
processor in corresspondence, promotions, etc.
LBy MOD.III of the example, both types of files will be probably be enhanced P
Nfor even greater synergy. This combined approach has a myriad of uses for all H
Ftypes of organizations and individuals. When database records require P
Nsophisticated analyses, convert to a spreadsheet for "number crunching." If a O
Mspreadsheet file limits report flexibility, etc., convert to a database. Use &
both to make AppleWorks really work.J
========================================================================